package com.cyf.db.mapper;

import com.cyf.db.bean.LocalCarWashCoupon;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author hfy
 * @date 2018/7/11
 */
public interface LocalCarWashCouponMapper {


    @Select("select * from local_carwash_coupon " +
            "where personId = #{personId} and parkingId = #{parkingId} and status = 1 " +
            "order by endTime desc ")
    List<LocalCarWashCoupon> getCanUsedByPersonIdAndParkingId(@Param("personId") Integer personId, @Param("parkingId") Integer parkingId);
}
